Examen de Access

What is the first step in creating a table in Access?

• The first step in creating a table in Access is to close the database file.

• The first step in creating a table in Access is to delete an existing database file.

• The first step in creating a table in Access is to open a new or existing database file.

• The first step in creating a table in Access is to create a query instead of a table.

Explain the process of designing a form in Access.

• To design a form in Access, you need to write complex code from scratch

• Designing a form in Access involves using a separate software outside of Access

• The process of designing a form in Access is automatic and does not require any user input

• To design a form in Access, you can use the Form Design Tool to add and arrange form controls, set properties for the form and controls, and then save the form.

What is a query in Access and how is it used?

• A query in Access is a tool for formatting and designing the layout of a database form.

• A query in Access is a request for specific information from a database. It is used to retrieve, filter, and display data from one or more tables based on specified criteria.

• A query in Access is a feature used for creating animations and special effects in presentations.

• A query in Access is a type of computer virus that can infect databases and corrupt data.

Describe the steps involved in generating a report in Access.

• Click on the 'Home' tab and select 'Report' from the drop-down menu

• 1. Open the Access database and select the table or query that contains the data you want to include in the report. 2. Go to the 'Create' tab and click on 'Report' in the 'Reports' group. 3. Access will generate a basic report layout based on the selected data. You can then customize the report by adding fields, grouping data, and applying formatting as needed.

• Access will automatically generate a report when you open the database

• Use the 'Design' tab to manually create the report layout

What are macros in Access and how are they used?

• Macros in Access are used to automate tasks and add functionality to forms, reports, and controls. They can be used to perform actions such as opening forms, running queries, and executing other macros.

• Macros in Access are used to create new databases and tables.

• Macros in Access are used for formatting text in tables and reports.

• Macros in Access are used to calculate mathematical functions in forms and reports.

What are the different data types that can be used when creating a table in Access?

• Apple, Banana, Orange, Grape

• Text, Memo, Number, Date/Time, Currency, AutoNumber, Yes/No, OLE Object, Hyperlink, and Attachment

• Red, Blue, Green, Yellow

• Dog, Cat, Bird, Fish

How can you add a calculated field to a form in Access?

• Create a separate query for the calculated field and link it to the form

• Use the Design Wizard to automatically add a calculated field

• Use the Expression Builder to create the calculation and then add it as a new field in the form design view.

• Manually write the calculation in the form's data source

Explain the concept of parameter queries in Access.

• Parameter queries in Access are used to store passwords for database security.

• Parameter queries in Access allow users to create queries that prompt for input when they are run.

• Parameter queries in Access are used to create visual reports of query results.

• Parameter queries in Access are used to automatically update data in the database.

What are the different types of reports that can be generated in Access?

• Invoices, receipts, and purchase orders

• The different types of reports that can be generated in Access include tabular reports, summary reports, and mailing labels.

• Line graphs, area charts, and histograms

• Pie charts, bar graphs, and scatter plots

How can you create a button to run a macro in Access?

• Create a text box and set its OnClick event property to the name of the macro.

• Use a drop-down menu and set its OnClick event property to the name of the macro.

• Add a label to the form and set its OnClick event property to the name of the macro.

• Add a command button to a form and set its OnClick event property to the name of the macro.