CGS Access Practice Exam

These questions are part of the practice quiz. Start practicing

• What should you select to export the 'Tuition' query to Excel with formatting?
• What is the function of a form in Microsoft Access?
• To run an update query, what information is necessary to input?
• When would you most likely need to use the 'Compact and Repair Database' function?
• How can you set a default value for a field in Access?
• Which action will help hide the status bar in an Access database?
• Which types of data can be stored in an Access database?
• Which property sheet option is used to display a validation message in a table?
• What should be added to the SELECT clause when modifying a SQL view to include department names?
• Which property should be modified to change the application title in Access?
• When setting criteria to filter for last names beginning with 'A', which SQL phrase is appropriate?
• How can you create a back-end database in Access?
• How do you filter records using the 'Advanced Filter/Sort'?
• What initial steps are needed to create a new query in the Design view?
• What is the correct method for aligning selected controls at the top in the Report Design?
• How do you create a new custom category in the Navigation Pane?
• In Access, what does the 'Append' button do in a query?
• What does database security in Access involve?
• What does the 'Compact and Repair Database' function do in Access?
• To ensure only 'Male' and 'Female' can be selected in the 'Gender' field, what option must be checked?
• What does a query in Access allow users to do?
• Which of the following methods can enforce data consistency in Access?
• What command is used to save the database options in Access?
• What is the correct process to switch the Navigation Pane to show a custom category?
• How do you change the tab order of controls in a form?
• What action must be taken to open the 'Run Tuition Query' macro for editing?
• What types of relationships can be established between tables in Access?
• How do reports differ from queries in Access?
• Where do you find the option to run a macro in Access?
• Which query type would you use to modify existing records in a database?
• How can a calculated control be added to a form in Access?
• What is the significance of the Design View in Access?
• In which property can you modify a form to prevent new records from being added?
• What is an example of a query in Access?
• What is a common use of the SQL View in Access?
• What is the first step to add a subreport control in Design view?
• Which step is necessary to filter query results using AutoFilter?
• What is the main advantage of using queries in Access?
• What does the Report option in Access allow you to do with a query?
• What fields should be included when using the Form Wizard for creating a new form?
• What does SQL stand for in the context of Access?
• How can you access the Property Sheet for a form?
• Which setting should be adjusted to display the 'Navigation Form' at startup in Access?
• When performing alignment of controls, what specific alignment option do you select?
• How do you modify controls to be the same size as the tallest control?
• What is the correct order to sort records by multiple fields?
• What is required to create a relationship between 'EmployeeID' in the 'Professor' table and 'Advisor' in the 'Student' table?
• How can you create a new blank report in Design view?
• How is an image added to a form in the Detail section of Access?
• Which button is used to set the 'ClassSchedule' query as the report's record source?
• What function does a query parameter serve in Access?
• What steps are necessary to remove a password from a database?
• How can data be exported from Access to Word?
• What must you do after naming a new table 'Tuition2016' in a make table query?
• Which of the following actions would most likely require a field size adjustment in Access tables?
• In the process of creating a subreport, what must be linked to the main report?
• How can you disable editing for a specific text control in a form?
• Which button would you use to run a modified SQL query in Access?
• How can you change the layout of a report in Access?
• What option should you select to show only specific records based on criteria?
• What is the first step to modify the 'Gender' field to use a lookup list?
• What is the function of the "Find Unmatched Query Wizard"?
• When saving a new table after creation, what should be typed in the Table Name box?
• What is a 'parameter query' used for in Access?
• What wizard should be used to create a query that identifies RAs assigned to multiple residence halls?
• How can you delete an action from a macro in Access?
• How do you change the 'Border Style' property of a control in Access?
• What is a 'snapshot' in Access?
• What distinguishes a 'relationship' from a 'join' in Access?
• Why is it important to create relationships between tables in Access?
• To convert a query into a 'make table' query, what must you click in the Query Tools Design tab?
• How can users enhance data entry efficiency in Access?
• What is the method to disable Layout view for forms and reports?
• What are the main components of an Access database?
• How can you create a calculated field in Access?
• To delete records from an underlying table, which query should be selected?
• How can you delete a record from a table in Access?
• What are the first steps to create a new query using Design View in Access?
• Which query would be selected to copy records that meet specific criteria?
• Which option must be selected to create a form that organizes entries in a datasheet subform?
• Which option allows you to import data while keeping the field information unchanged?
• How can you create a query in Access?
• What type of key should be used as the primary key during import from Excel?
• How can records be filtered in a datasheet view in Access?
• Which option disables scroll bars for a form in Design view?
• How can you apply conditional formatting to display data bars in Access?
• What is a lookup field in Access primarily used for?
• How do you add an image to the form header using Design view?
• To hide duplicate values in a report, which property should be set to 'Yes'?
• Which tab contains the tools for analyzing database performance in Access?
• How do you update data in Access?
• How can you hide the Navigation Pane when opening a database?
• What action should be taken to add a subform control to a form?
• What does 'Layout View' allow users to do?
• What control must be added to a form to include a subform?
• To create a new form based on the 'Details' application part, you should:
• What should you do to open the Access Options dialog in Access?
• What action is required to filter records in the Department table to show only 'Marketing'?
• Which action must be taken after typing the new field in the SQL view to see results?
• What is the primary function of the Navigation Pane in Access?
• To import Excel fields into a new table in Access, what should the first row contain?
• What is the first action needed to create a new table in Design view?
• What best describes a report in Microsoft Access?
• How can you hide navigation buttons from a subform in Access?
• What function does the 'Find' tool serve in Access?
• To filter records only where the 'Days' field is 'TTh', which criteria should be set?
• What is a primary key in an Access database?
• What steps are involved in creating a navigation form with horizontal tabs?
• What is the first step to create a new blank form in Design View?
• How do you display the report sections at the beginning and end of a report?
• What is required when setting a validation rule for the 'DueDate' field to ensure it's greater than the 'Date' field?
• What does the term 'flat file' refer to in a database context?
• Which of the following actions will trigger Access to display report data by the 'Departments' table?
• What do you do to disable design functions for tables in Datasheet view?
• Which step is necessary to rename a table during the analysis process?
• What does 'aggregation' refer to in Access?
• Which SQL command is used to modify records based on specific criteria?
• What should you select as the column headings in a crosstab query?
• What must be set when importing data from a CSV file to designate a primary key?
• What characterizes a composite primary key in Access?
• What data type should be selected for the 'RA ID' field in the new table?
• What is a subquery?
• To run a modified query after changing the grouping settings, which button should you click?
• To add a form header and footer in Access, which action is appropriate?
• What is the purpose of input masks in Access?
• Why is it important to set field sizes in Access tables?
• How do you create a relationship between two tables in Access?
• Which action should be taken to open the 'University Registration' database with exclusive access?
• Which button do you click to start creating a new stand-alone macro?
• Which function is used to summarize the 'Credits' field in a query?
• What are 'groups' used for in reports within Access?
• In Access, what does the term 'table' refer to?
• How do you add a subreport to the Detail section of a report?
• What is conditional formatting used for in Access?
• Where would you find the 'Property Sheet' button in Access?
• To modify the database options for the title bar, which tab must you access first?
• Which option allows you to group all database objects of the same type in the Navigation Pane?
• What is the purpose of the 'Input Mask' property in data entry forms?
• What should you do after adding fields to a new report in Access?
• What is an 'expression' in Access?
• Why is regular backup of an Access database essential?
• To set a field as the primary key, which button should be clicked after selecting the field?
• How can you create a new table in Access?
• What is the primary purpose of a macro in Access?
• Which feature allows you to create a summary of data in Access?
• How do you initiate an update query in Access?
• Which method is used to create a filter for a specific content in a field?
• What format is used to save a locked version of a database?
• What step needs to be taken to copy records to the 'ClassArchive2016' table?
• What is the purpose of the 'Totals' row in Access queries?
• What method allows you to access the Property Sheet in a Form Design view?
• What is normalization in the context of database design?
• How can you view the SQL code for a query in Access?
• What property do you modify to restrict data entry in a form to new records only?
• How do you add a comment to a macro about tuition calculation?
• What is the final step to finish the process of table creation in Access?
• To modify controls for alignment in Design view, which tab do you access?
• What happens to the data in a select query when it is executed?
• What is the purpose of Microsoft Access?
• Which setting should be changed to eliminate design changes for tables in Datasheet view?
• What is the final step after defining criteria in a summary query in Access?
• Which action is required to rename a table in Access?
• How can you display the group without a header section in Access?
• To create a linked table, what action must follow after selecting the database?
• How do you display the group footer in a report?
• Which query wizard is used to create a crosstab query?
• What is the first step to create a linked table to the 'TuitionRates' table in another database?
• Which action is required after typing the validation message in the Validation Text box?
• What is the correct way to create a new desktop database from a template?
• What is a control in Access forms?
• When using the Report Wizard, which field should be added first from the Departments table?
• What is a 'join' in Access?
• What is the function of the "Make ACCDE" command when saving a database?
• How can data be imported into Access from Excel?
• How can you create a report based on a query in Access?
• What is the first step to open the Navigation Pane in Access?
• After setting a validation rule, what must you do to apply it to the database?
• What is the purpose of the 'Subform/Subreport' button?
• How can referential integrity be enforced in Access?
• What role do text boxes play in Access forms?
• What type of control is primarily used for displaying calculations in Access forms?
• Why would you choose to create a back-end database?
• What must you do to switch to SQL view for modifying a query?
• What should you do to add a group named 'GPA Forms' under a new category?
• What is the primary difference between action queries and select queries in Access?
• What is the purpose of using criteria in the Design View of a query?
• In Access, what is the significance of a unique identifier?
• How can you accept primary key recommendations during a table analysis?
• What is the purpose of the Database Documenter in Access?
• What is the role of a 'join' in Access?
• What functionality do combo boxes provide in Access forms?
• Which query is used to copy records to a new table based on criteria?
• What action should be taken to increase the values in the 'CreditHourFee' field by 25%?
• What is the purpose of user permissions in an Access database?
• What role do relationships play between tables in Access databases?