Unit 2, try it
What must we understand first in order to understand Microsoft Access?
Press a choice to see the answer.
Form 4 Technology (ICT)
Unit 2: Microsoft Access 2016 questions and answers
554 practice questions on Microsoft Access 2016, covering all 6 lessons of the unit. Each has its answer and an explanation. Free.
How many questions?
A free account is needed to start, so your answers and results are saved.
Microsoft Access 2016: sample questions with answers
Unit 2, try it
What is the first step to open Microsoft Access 2016?
Press a choice to see the answer.
Unit 2, try it
In Access, what are the rows of a table referred to as?
Press a choice to see the answer.
Unit 2, try it
Which real life example of filling out forms does the book give?
Press a choice to see the answer.
Unit 2, try it
Which kind of query does the lesson teach you to create first?
Press a choice to see the answer.
Unit 2, try it
From what can Access create and customize a report?
Press a choice to see the answer.
What unit 2 covers
Questions follow the book: Technology, Secondary, Form Four, Student Book.
Lesson 1: Introduction to Database Management
- Overview
- What is a database?
- Why do we use a database?
- The advantages of having a database include:
- Disadvantages of Database
- Database Objects:
- I. Tables
- Table 2.1: Microsoft Access Data Types
- II. Forms
- III. Queries
- IV. Reports
Lesson 2: Managing Databases and Objects
- Getting Started Microsoft Access 2016
- To open Microsoft Access 2016:
- Working with your Access environment
- The Ribbon
- To minimize and maximize the Ribbon:
- The Quick Access Toolbar
- Backstage view
- The Navigation pane
- To minimize and maximize the Navigation pane:
- Sorting Objects in the Navigation pane
- Creating a database
- Creating a Table
- To open an existing database:
- To close a database:
- To open an object:
- Saving objects
- To close an object:
- To rename an object:
Lesson 3: Working with Tables
- Table basics
- To open an existing table:
- Navigating within tables
- Adding records and entering data
- To save a record:
- Editing records
- To delete a record:
- Resizing fields and rows
- Hiding fields
- Alternate row color
- Creating Primary Keys in a Table
- To create a Primary Keys
Lesson 4: Working with Forms
- Overview
- Why use forms?
- To create a form
- To open an existing form:
- To add a new record:
- To find an existing record to view or edit:
- To save the current record:
- To delete the current record;
Lesson 5: Designing a Query
- Overview
- What are queries?
- Advantages of query:
- To create a simple query:
- To modify a query:
- Designing a Multi table Query
- Planning a query
- Creating a multi table query
Lesson 6: Creating Reports
- Overview
- To create a report:
- To save your report:
- To delete a field in a report:
- Printing reports in Print Preview
