Questions and Answers
What action do you take to open the Course table?
What should you name the new table created in Datasheet view?
Degrees
What is the correct way to replace all instances of 'julie' with 'Julie'?
Use the Replace button in the Find and Replace dialog.
The Navigation Pane can be opened by clicking the Shutter Bar Open/Close button.
Signup and view all the answers
Which input mask format should be applied to the StartDate field?
Signup and view all the answers
How do you add the LastName field from the Students table to the form in Layout view?
Signup and view all the answers
You can create a new blank database named Accounting by using the New navigation button in backstage view.
Signup and view all the answers
Which fields do you need to include when creating a new form using the Form Wizard?
Signup and view all the answers
What fields should be added when creating a new query in Design view?
Signup and view all the answers
Study Notes
General Access Tasks
- To open the Course table, double-click on the table.
- Create a new table named "Degrees" by accessing the Create Ribbon Tab, selecting the Table button, and saving it in the Save As dialog.
Text Replacement
- Replace all instances of the name "julie" with "Julie" using the Replace feature in the Home Ribbon Tab, ensuring the Match Case option is selected.
Navigation and Formatting
- The Navigation Pane can be opened by clicking the Shutter Bar Open/Close button.
- Apply the Short Date input mask to the StartDate field through the Input Mask property settings.
Form Management
- Use the Field List pane to add the LastName field from the Students table to the form while in Layout view.
- Create a new blank database named "Accounting" via the backstage view, selecting the Blank database template and giving it the appropriate name.
Form Creation
- Utilize the Form Wizard to create a new form with specified fields from both the Departments and Courses tables, structured with Departments as the main form and Courses as a subform.
Query Design
- In Design view, create a new query that includes LastName, FirstName, Classification, and ResidenceHall from the Students table, and ResidenceName and FreshmenOnly from the ResidenceHalls table, before running the query.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
This quiz focuses on basic tasks and functionalities in database management, including table creation, data replacement, formatting, and form management. It aims to reinforce knowledge on how to navigate and utilize various features in a database application effectively.
