First knowledge of Access

Access is a relational database management system (RDBMS) launched by Microsoft Corporation in the United States, which is a relational database management system (RDBMS) launched by Microsoft in the United States, as part of office with Word, The same operating interface as Excel and PowerPoint, and part of office, have the same operating interface and use environment as Word, Excel, and PowerPoint, and are well liked by the vast majority of users. This chapter mainly introduces Access 2007 working interface, database for the environment, deeply favored by the majority of users. This chapter focuses on the work interface of Access 2007, database objects and their relationships, the types of data used in an Access database, and expressions and functions. Like and the relationships between them, the data types used in the Access database, and expressions and functions.

Teaching emphases and difficulties

Work interface for Access 2007 UI 2007 work interface data in Access information in Access objects in Access functions in Access

　　1.1 Start Access 2007 Start Access

After the user installs Office 2007 (typical installation), Access 2007 is also successfully installed to the system after the user installs Office 2007 (typical installation), Access 2007 is also successfully installed into the system. When you start Access, you can use it to create a database. , you can use it to create a database when you start Access.

　　1.2 Access 2007 Working interface 2007 working interface

Access 2007 is part of Microsoft Office 2007, and Office 2007 shows an open 2007 is part of 2007, and Office 2007 shows an open, vibrant new look, as shown in the figure.

1.2.1 title bar

The title bar, located at the top of the window, is part of an Access application window that displays the title bar, located at the top of the window, as part of the Access application window, to display the current application name, the edited database name, and the format of the database save. The right end of the title bar has 3 buttons, which are used to control the maximum/restore, minimize, and close the application, as shown in the button, to control the maximum/show of the window respectively.

1.2.2 Functional Area

Access 2007 cancels the menu command, converts the menu bar to the appropriate tab, and each option 2007 cancels the menu command, converts the menu bar to the appropriate tab, and lists the groups of different features below each tab. Groups such as font, rich text, sorting, and filtering are included in the Start tab, as shown in the figure.

1.2.3 Navigation Pane

The Navigation Pane, located in the area to the left of the window, displays the name of the database object, such as the area on the left side of the window where the Navigation Pane displays the name of the database object, as shown in Figure 2-7. The Navigation Pane replaces the Database window in an earlier version of Access, as shown in the figure. The Navigation Pane replaces the Database window in an earlier version of Access, as shown in the figure.

1.2.4 Work Area

The workspace is the largest part of the Access 2007 working interface, which shows the various workspaces in the database as the largest part of the Access 2007 working interface, which displays the various objects in the database and is the primary work area for database operations using Access. Object that is the primary work area for database operations using Access.

1.2.5 Status bar

The status bar, located at the bottom of the program window, displays status information and includes buttons that can be used to change the view, as shown in the figure.

1.2.6 Other interface elements

The Access 2007 interface also contains other elements that have something in common: new elements, and the 2007 interface contains other elements in common: new elements, and the ability to help users execute commands easily. Office Button Office Button Quick Access Toolbar

　　1.3 Custom Work interface

Access 2007 supports custom settings work environment features, users can arrange according to their own preferences 2007 support custom settings work environment features, users can according to their preferences to arrange access to the interface elements, so that access to the work of human interface. Access's interface elements, which makes access's working interface more humane. Customizing the Quick Access Toolbar customizing your work environment

1.3.1 Custom Quick Access Toolbar

Click the drop-down arrow to the right of the Quick Access Toolbar to eject the list of frequently used commands. When you select the command you want, the button that corresponds to the command is automatically added to the Quick Access Toolbar. Add command button Quick Access Toolbar position adjustment

1.3.2 Custom Work environment

In Access 2007, users can set up a working environment. Click the Office Button, and in the pop-up 2007, the user can set up the work environment. Click the Office Button, click the Access 2007 option button in the pop-up menu, click the Access 2007 Options button in the menu that appears in the Open Access Options dialog box, and then set it in the Open Access Options dialog box, as shown in the figure.

　　1.4 Objects in Access in Access

The table is an object of an Access database, and in addition to the objects in the Access 2007 database, the object of the query, the table is an object of an Access database, and in addition to the objects in the Access 2007 database include queries, forms, reports, macros, and modules. The Table object Query Object Form Object Report Object macro object Module object.

1.4.1 Table Objects Table

A table is a collection of the same type of data, and also the place where data is saved in an Access database, such as the collection of the same class of data in the left table, and where the data is saved in an Access database, as shown in the figure on the left. A database can contain one or more tables, and a relationship can be created as needed between tables, as shown in the picture on the right.