Lesson 2: Parts of MS Access Flashcards
(18 cards)
It is a well-known database management system produced by Microsoft and is part of the Microsoft 365 suite.
MS Access
Microsoft Access combines Microsoft’s ___ with software development tools and a graphic user interface.
relational Jet Database Engine`
It was first released in November 1992, so it’s been around for a while. In the rapidly changing, fast-paced IT world, we can best describe a 30-year-old program as “venerable.”
MS Access
What are the features of MS Access?
- Right and optimum utilization of data
- Import and export
- Queries to extract and analyse data
It appears on the top of the window and displays the name of the document on which you are currently working on.
Title Bar
It is present on the top left corner of the Access window. It has buttons for commands that are used frequently.
Quick Access Toolbar
It contains multiple tabs, each with several groups of commands.
Ribbon
It displays the names of all the objects in the database.
Navigation Pane
It displays the current record number in an object.
Navigation Buttons
It is where the objects that you have opened in a database which appear in a tabbed form.
Object Tabs
It appears at the bottom of the window displaying the datasheet view and design view.
Status Bar
It is where you work on objects such as tables, forms, and reports.
Work Area
It is used to switch from one view to another view.
View Button
In this view, you can enter the field name, their data types, description, and properties.
Design View
In this view, you can enter data in the table.
Datasheet View
What are the types of data?
- Short Text
- Long Text
- Number
- Date/Time
- Currency
- AutoNumber
- Yes/No
What is the character limit for short text?
255 characters
What is the character limit for long text?
63,999
